<html>
<head>
<title>File Source for Workbook.php</title>
<link rel="stylesheet" type="text/css" href="../media/style.css">
</head>
<body>

<table border="0" cellspacing="0" cellpadding="0" height="48" width="100%">
  <tr>
    <td class="header_top">PHPExcel_Writer_Excel2007</td>
  </tr>
  <tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt=""  /></td></tr>
  <tr>
    <td class="header_menu">
  		  [ <a href="../classtrees_PHPExcel_Writer_Excel2007.html" class="menu">class tree: PHPExcel_Writer_Excel2007</a> ]
		  [ <a href="../elementindex_PHPExcel_Writer_Excel2007.html" class="menu">index: PHPExcel_Writer_Excel2007</a> ]
		  [ <a href="../elementindex.html" class="menu">all elements</a> ]
    </td>
  </tr>
  <tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt=""  /></td></tr>
</table>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr valign="top">
    <td width="200" class="menu">
      <b>Packages:</b><br />
              <a href="../li_PHPExcel.html">PHPExcel</a><br />
              <a href="../li_PHPExcel_Cell.html">PHPExcel_Cell</a><br />
              <a href="../li_PHPExcel_Reader.html">PHPExcel_Reader</a><br />
              <a href="../li_PHPExcel_Shared.html">PHPExcel_Shared</a><br />
              <a href="../li_PHPExcel_Style.html">PHPExcel_Style</a><br />
              <a href="../li_PHPExcel_Worksheet.html">PHPExcel_Worksheet</a><br />
              <a href="../li_PHPExcel_Worksheet_Drawing.html">PHPExcel_Worksheet_Drawing</a><br />
              <a href="../li_PHPExcel_Writer.html">PHPExcel_Writer</a><br />
              <a href="../li_PHPExcel_Writer_Excel2007.html">PHPExcel_Writer_Excel2007</a><br />
            <br /><br />
                  
                </td>
    <td>
      <table cellpadding="10" cellspacing="0" width="100%" border="0"><tr><td valign="top">

<h1 align="center">Source for file Workbook.php</h1>
<p>Documentation is available at <a href="../PHPExcel_Writer_Excel2007/_Classes_PHPExcel_Writer_Excel2007_Workbook_php.html">Workbook.php</a></p>
<div class="php">
<div class="listing"><pre><ol><li><a name="a1"></a><span class="src-php">&lt;?php</span></li>
<li><a name="a2"></a><span class="src-doc">/**</span></li>
<li><a name="a3"></a><span class="src-doc"> * PHPExcel</span></li>
<li><a name="a4"></a><span class="src-doc"> *</span></li>
<li><a name="a5"></a><span class="src-doc"> * Copyright (c) 2006 - 2007 PHPExcel, Maarten Balliauw</span></li>
<li><a name="a6"></a><span class="src-doc"> *</span></li>
<li><a name="a7"></a><span class="src-doc"> * This library is free software; you can redistribute it and/or</span></li>
<li><a name="a8"></a><span class="src-doc"> * modify it under the terms of the GNU Lesser General Public</span></li>
<li><a name="a9"></a><span class="src-doc"> * License as published by the Free Software Foundation; either</span></li>
<li><a name="a10"></a><span class="src-doc"> * version 2.1 of the License, or (at your option) any later version.</span></li>
<li><a name="a11"></a><span class="src-doc"> * </span></li>
<li><a name="a12"></a><span class="src-doc"> * This library is distributed in the hope that it will be useful,</span></li>
<li><a name="a13"></a><span class="src-doc"> * but WITHOUT ANY WARRANTY; without even the implied warranty of</span></li>
<li><a name="a14"></a><span class="src-doc"> * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU</span></li>
<li><a name="a15"></a><span class="src-doc"> * Lesser General Public License for more details.</span></li>
<li><a name="a16"></a><span class="src-doc"> * </span></li>
<li><a name="a17"></a><span class="src-doc"> * You should have received a copy of the GNU Lesser General Public</span></li>
<li><a name="a18"></a><span class="src-doc"> * License along with this library; if not, write to the Free Software</span></li>
<li><a name="a19"></a><span class="src-doc"> * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA</span></li>
<li><a name="a20"></a><span class="src-doc"> *</span></li>
<li><a name="a21"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@category</span><span class="src-doc">   PHPExcel</span></li>
<li><a name="a22"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc">    PHPExcel_Writer_Excel2007</span></li>
<li><a name="a23"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@copyright</span><span class="src-doc">  Copyright (c) 2006 - 2007 PHPExcel (http://www.codeplex.com/PHPExcel)</span></li>
<li><a name="a24"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@license</span><span class="src-doc">    http://www.gnu.org/licenses/lgpl.txt    LGPL</span></li>
<li><a name="a25"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@version</span><span class="src-doc">    ##VERSION##, ##DATE##</span></li>
<li><a name="a26"></a><span class="src-doc"> */</span></li>
<li><a name="a27"></a>&nbsp;</li>
<li><a name="a28"></a>&nbsp;</li>
<li><a name="a29"></a><span class="src-doc">/** PHPExcel_Writer_Excel2007 */</span></li>
<li><a name="a29"></a>&nbsp;</li>
<li><a name="a30"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel/Writer/Excel2007.php'</span><span class="src-sym">;</span></li>
<li><a name="a31"></a>&nbsp;</li>
<li><a name="a32"></a><span class="src-doc">/** PHPExcel_Writer_Excel2007_WriterPart */</span></li>
<li><a name="a32"></a>&nbsp;</li>
<li><a name="a33"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel/Writer/Excel2007/WriterPart.php'</span><span class="src-sym">;</span></li>
<li><a name="a34"></a>&nbsp;</li>
<li><a name="a35"></a><span class="src-doc">/** PHPExcel_Cell */</span></li>
<li><a name="a35"></a>&nbsp;</li>
<li><a name="a36"></a><span class="src-inc">require_once </span><span class="src-str">'PHPExcel/Cell.php'</span><span class="src-sym">;</span></li>
<li><a name="a37"></a>&nbsp;</li>
<li><a name="a38"></a>&nbsp;</li>
<li><a name="a39"></a><span class="src-doc">/**</span></li>
<li><a name="a40"></a><span class="src-doc"> * PHPExcel_Writer_Excel2007_Workbook</span></li>
<li><a name="a41"></a><span class="src-doc"> *</span></li>
<li><a name="a42"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@category</span><span class="src-doc">   PHPExcel</span></li>
<li><a name="a43"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc">    PHPExcel_Writer_Excel2007</span></li>
<li><a name="a44"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@copyright</span><span class="src-doc">  Copyright (c) 2006 - 2007 PHPExcel (http://www.codeplex.com/PHPExcel)</span></li>
<li><a name="a45"></a><span class="src-doc"> */</span></li>
<li><a name="a46"></a><span class="src-key">class </span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_Workbook.html">PHPExcel_Writer_Excel2007_Workbook</a> <span class="src-key">extends </span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_WriterPart.html">PHPExcel_Writer_Excel2007_WriterPart</a></li>
<li><a name="a47"></a><span class="src-sym">{</span></li>
<li><a name="a48"></a>    <span class="src-doc">/**</span></li>
<li><a name="a49"></a><span class="src-doc">     * Write workbook to XML format</span></li>
<li><a name="a50"></a><span class="src-doc">     *</span></li>
<li><a name="a51"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">PHPExcel </span><span class="src-doc">   </span><span class="src-doc-var">$pPHPExcel </span></li>
<li><a name="a52"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@return </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc">        XML Output</span></li>
<li><a name="a53"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">     Exception</span></li>
<li><a name="a54"></a><span class="src-doc">     */</span></li>
<li><a name="a55"></a>    <span class="src-key">public </span><span class="src-key">function </span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_Workbook.html#methodwriteWorkbook">writeWorkbook</a><span class="src-sym">(</span><span class="src-var">$pPHPExcel </span>= <span class="src-id">null</span><span class="src-sym">)</span></li>
<li><a name="a56"></a>    <span class="src-sym">{</span></li>
<li><a name="a57"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$pPHPExcel </span>instanceof <span class="src-id"><a href="../PHPExcel/PHPExcel.html">PHPExcel</a></span><span class="src-sym">) </span><span class="src-sym">{                    </span></li>
<li><a name="a58"></a>            <span class="src-comm">// Create XML writer</span></li>
<li><a name="a59"></a>            <span class="src-var">$objWriter </span>= <span class="src-key">new </span><span class="src-id">xmlWriter</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a60"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">openMemory</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a61"></a>            </li>
<li><a name="a62"></a>            <span class="src-comm">// XML header</span></li>
<li><a name="a63"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">startDocument</span><span class="src-sym">(</span><span class="src-str">'1.0'</span><span class="src-sym">,</span><span class="src-str">'UTF-8'</span><span class="src-sym">,</span><span class="src-str">'yes'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a64"></a>&nbsp;</li>
<li><a name="a65"></a>            <span class="src-comm">// workbook</span></li>
<li><a name="a66"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">startElement</span><span class="src-sym">(</span><span class="src-str">'workbook'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a67"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'xml:space'</span><span class="src-sym">, </span><span class="src-str">'preserve'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a68"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'xmlns'</span><span class="src-sym">, </span><span class="src-str">'http://schemas.openxmlformats.org/spreadsheetml/2006/main'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a69"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'xmlns:r'</span><span class="src-sym">, </span><span class="src-str">'http://schemas.openxmlformats.org/officeDocument/2006/relationships'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a70"></a>  </li>
<li><a name="a71"></a>                <span class="src-comm">// fileVersion</span></li>
<li><a name="a72"></a>                <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_Workbook.html#method_writeFileVersion">_writeFileVersion</a><span class="src-sym">(</span><span class="src-var">$objWriter</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a73"></a>                            </li>
<li><a name="a74"></a>                <span class="src-comm">// workbookPr</span></li>
<li><a name="a75"></a>                <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_Workbook.html#method_writeWorkbookPr">_writeWorkbookPr</a><span class="src-sym">(</span><span class="src-var">$objWriter</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a76"></a>                </li>
<li><a name="a77"></a>                <span class="src-comm">// workbookProtection</span></li>
<li><a name="a78"></a>                <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_Workbook.html#method_writeWorkbookProtection">_writeWorkbookProtection</a><span class="src-sym">(</span><span class="src-var">$objWriter</span><span class="src-sym">, </span><span class="src-var">$pPHPExcel</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a79"></a>            </li>
<li><a name="a80"></a>                <span class="src-comm">// sheets</span></li>
<li><a name="a81"></a>                <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_Workbook.html#method_writeSheets">_writeSheets</a><span class="src-sym">(</span><span class="src-var">$objWriter</span><span class="src-sym">, </span><span class="src-var">$pPHPExcel</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a82"></a>                </li>
<li><a name="a83"></a>                <span class="src-comm">// definedNames</span></li>
<li><a name="a84"></a>                <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_Workbook.html#method_writeDefinedNames">_writeDefinedNames</a><span class="src-sym">(</span><span class="src-var">$objWriter</span><span class="src-sym">, </span><span class="src-var">$pPHPExcel</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a85"></a>                </li>
<li><a name="a86"></a>                <span class="src-comm">// calcPr</span></li>
<li><a name="a87"></a>                <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_Workbook.html#method_writeCalcPr">_writeCalcPr</a><span class="src-sym">(</span><span class="src-var">$objWriter</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a88"></a>  </li>
<li><a name="a89"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">endElement</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a90"></a>&nbsp;</li>
<li><a name="a91"></a>            <span class="src-comm">// Return</span></li>
<li><a name="a92"></a>            <span class="src-key">return </span><span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">outputMemory</span><span class="src-sym">(</span><span class="src-id">true</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a93"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a94"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Invalid PHPExcel object passed.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a95"></a>        <span class="src-sym">}</span></li>
<li><a name="a96"></a>    <span class="src-sym">}</span></li>
<li><a name="a97"></a>                </li>
<li><a name="a98"></a>    <span class="src-doc">/**</span></li>
<li><a name="a99"></a><span class="src-doc">     * Write file version</span></li>
<li><a name="a100"></a><span class="src-doc">     *</span></li>
<li><a name="a101"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">xmlWriter </span><span class="src-doc-var">$objWriter </span><span class="src-doc">        XML Writer</span></li>
<li><a name="a102"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">     Exception</span></li>
<li><a name="a103"></a><span class="src-doc">     */</span></li>
<li><a name="a104"></a>    <span class="src-key">private </span><span class="src-key">function </span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_Workbook.html#method_writeFileVersion">_writeFileVersion</a><span class="src-sym">(</span><span class="src-var">$objWriter </span>= <span class="src-id">null</span><span class="src-sym">)</span></li>
<li><a name="a105"></a>    <span class="src-sym">{</span></li>
<li><a name="a106"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$objWriter </span>instanceof <span class="src-id">xmlWriter</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a107"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">startElement</span><span class="src-sym">(</span><span class="src-str">'fileVersion'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a108"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'appName'</span><span class="src-sym">, </span><span class="src-str">'xl'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a109"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'lastEdited'</span><span class="src-sym">, </span><span class="src-str">'4'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a110"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'lowestEdited'</span><span class="src-sym">, </span><span class="src-str">'4'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a111"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'rupBuild'</span><span class="src-sym">, </span><span class="src-str">'4505'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a112"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">endElement</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a113"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a114"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Invalid parameters passed.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a115"></a>        <span class="src-sym">}</span></li>
<li><a name="a116"></a>    <span class="src-sym">}</span></li>
<li><a name="a117"></a>&nbsp;</li>
<li><a name="a118"></a>    <span class="src-doc">/**</span></li>
<li><a name="a119"></a><span class="src-doc">     * Write WorkbookPr</span></li>
<li><a name="a120"></a><span class="src-doc">     *</span></li>
<li><a name="a121"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">xmlWriter </span><span class="src-doc-var">$objWriter </span><span class="src-doc">        XML Writer</span></li>
<li><a name="a122"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">     Exception</span></li>
<li><a name="a123"></a><span class="src-doc">     */</span></li>
<li><a name="a124"></a>    <span class="src-key">private </span><span class="src-key">function </span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_Workbook.html#method_writeWorkbookPr">_writeWorkbookPr</a><span class="src-sym">(</span><span class="src-var">$objWriter </span>= <span class="src-id">null</span><span class="src-sym">)</span></li>
<li><a name="a125"></a>    <span class="src-sym">{</span></li>
<li><a name="a126"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$objWriter </span>instanceof <span class="src-id">xmlWriter</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a127"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">startElement</span><span class="src-sym">(</span><span class="src-str">'workbookPr'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a128"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'codeName'</span><span class="src-sym">, </span><span class="src-str">'ThisWorkbook'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a129"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">endElement</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a130"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a131"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Invalid parameters passed.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a132"></a>        <span class="src-sym">}</span></li>
<li><a name="a133"></a>    <span class="src-sym">}</span></li>
<li><a name="a134"></a>    </li>
<li><a name="a135"></a>    <span class="src-doc">/**</span></li>
<li><a name="a136"></a><span class="src-doc">     * Write WorkbookProtection</span></li>
<li><a name="a137"></a><span class="src-doc">     *</span></li>
<li><a name="a138"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">xmlWriter </span><span class="src-doc-var">$objWriter </span><span class="src-doc">        XML Writer</span></li>
<li><a name="a139"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">PHPExcel </span><span class="src-doc">   </span><span class="src-doc-var">$pPHPExcel </span></li>
<li><a name="a140"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">     Exception</span></li>
<li><a name="a141"></a><span class="src-doc">     */</span></li>
<li><a name="a142"></a>    <span class="src-key">private </span><span class="src-key">function </span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_Workbook.html#method_writeWorkbookProtection">_writeWorkbookProtection</a><span class="src-sym">(</span><span class="src-var">$objWriter </span>= <span class="src-id">null</span><span class="src-sym">, </span><span class="src-var">$pPHPExcel </span>= <span class="src-id">null</span><span class="src-sym">)</span></li>
<li><a name="a143"></a>    <span class="src-sym">{</span></li>
<li><a name="a144"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$objWriter </span>instanceof <span class="src-id">xmlWriter </span>&amp;&amp; <span class="src-var">$pPHPExcel </span>instanceof <span class="src-id"><a href="../PHPExcel/PHPExcel.html">PHPExcel</a></span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a145"></a>            <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$pPHPExcel</span><span class="src-sym">-&gt;</span><span class="src-id">getSecurity</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">isSecurityEnabled</span><span class="src-sym">(</span><span class="src-sym">)) </span><span class="src-sym">{</span></li>
<li><a name="a146"></a>                <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">startElement</span><span class="src-sym">(</span><span class="src-str">'workbookProtection'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a147"></a>                <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'lockRevision'</span><span class="src-sym">,        </span><span class="src-sym">(</span><span class="src-var">$pPHPExcel</span><span class="src-sym">-&gt;</span><span class="src-id">getSecurity</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">getLockRevision</span><span class="src-sym">(</span><span class="src-sym">) </span>? <span class="src-str">'true' </span>: <span class="src-str">'false'</span><span class="src-sym">))</span><span class="src-sym">;</span></li>
<li><a name="a148"></a>                <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'lockStructure'</span><span class="src-sym">,     </span><span class="src-sym">(</span><span class="src-var">$pPHPExcel</span><span class="src-sym">-&gt;</span><span class="src-id">getSecurity</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">getLockStructure</span><span class="src-sym">(</span><span class="src-sym">) </span>? <span class="src-str">'true' </span>: <span class="src-str">'false'</span><span class="src-sym">))</span><span class="src-sym">;</span></li>
<li><a name="a149"></a>                <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'lockWindows'</span><span class="src-sym">,         </span><span class="src-sym">(</span><span class="src-var">$pPHPExcel</span><span class="src-sym">-&gt;</span><span class="src-id">getSecurity</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">getLockWindows</span><span class="src-sym">(</span><span class="src-sym">) </span>? <span class="src-str">'true' </span>: <span class="src-str">'false'</span><span class="src-sym">))</span><span class="src-sym">;</span></li>
<li><a name="a150"></a>                </li>
<li><a name="a151"></a>                <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$pPHPExcel</span><span class="src-sym">-&gt;</span><span class="src-id">getSecurity</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">getRevisionsPassword</span><span class="src-sym">(</span><span class="src-sym">) </span>!= <span class="src-str">''</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a152"></a>                    <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'revisionsPassword'</span><span class="src-sym">,    </span><span class="src-var">$pPHPExcel</span><span class="src-sym">-&gt;</span><span class="src-id">getSecurity</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">getRevisionsPassword</span><span class="src-sym">(</span><span class="src-sym">))</span><span class="src-sym">;</span></li>
<li><a name="a153"></a>                <span class="src-sym">}</span></li>
<li><a name="a154"></a>                </li>
<li><a name="a155"></a>                <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$pPHPExcel</span><span class="src-sym">-&gt;</span><span class="src-id">getSecurity</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">getWorkbookPassword</span><span class="src-sym">(</span><span class="src-sym">) </span>!= <span class="src-str">''</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a156"></a>                    <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'workbookPassword'</span><span class="src-sym">,    </span><span class="src-var">$pPHPExcel</span><span class="src-sym">-&gt;</span><span class="src-id">getSecurity</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">getWorkbookPassword</span><span class="src-sym">(</span><span class="src-sym">))</span><span class="src-sym">;    </span></li>
<li><a name="a157"></a>                <span class="src-sym">}</span></li>
<li><a name="a158"></a>                </li>
<li><a name="a159"></a>                <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">endElement</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a160"></a>            <span class="src-sym">}</span></li>
<li><a name="a161"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a162"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Invalid parameters passed.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a163"></a>        <span class="src-sym">}</span></li>
<li><a name="a164"></a>    <span class="src-sym">}</span></li>
<li><a name="a165"></a>            </li>
<li><a name="a166"></a>    <span class="src-doc">/**</span></li>
<li><a name="a167"></a><span class="src-doc">     * Write calcPr</span></li>
<li><a name="a168"></a><span class="src-doc">     *</span></li>
<li><a name="a169"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">xmlWriter </span><span class="src-doc-var">$objWriter </span><span class="src-doc">        XML Writer</span></li>
<li><a name="a170"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">     Exception</span></li>
<li><a name="a171"></a><span class="src-doc">     */</span></li>
<li><a name="a172"></a>    <span class="src-key">private </span><span class="src-key">function </span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_Workbook.html#method_writeCalcPr">_writeCalcPr</a><span class="src-sym">(</span><span class="src-var">$objWriter </span>= <span class="src-id">null</span><span class="src-sym">)</span></li>
<li><a name="a173"></a>    <span class="src-sym">{</span></li>
<li><a name="a174"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$objWriter </span>instanceof <span class="src-id">xmlWriter</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a175"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">startElement</span><span class="src-sym">(</span><span class="src-str">'calcPr'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a176"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'calcId'</span><span class="src-sym">, </span><span class="src-str">'122211'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a177"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'calcMode'</span><span class="src-sym">, </span><span class="src-str">'auto'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a178"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'fullCalcOnLoad'</span><span class="src-sym">, </span><span class="src-str">'true'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a179"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">endElement</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a180"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a181"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Invalid parameters passed.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a182"></a>        <span class="src-sym">}</span></li>
<li><a name="a183"></a>    <span class="src-sym">}    </span></li>
<li><a name="a184"></a>    </li>
<li><a name="a185"></a>    <span class="src-doc">/**</span></li>
<li><a name="a186"></a><span class="src-doc">     * Write sheets</span></li>
<li><a name="a187"></a><span class="src-doc">     *</span></li>
<li><a name="a188"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">xmlWriter </span><span class="src-doc">    </span><span class="src-doc-var">$objWriter </span><span class="src-doc">        XML Writer</span></li>
<li><a name="a189"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">PHPExcel </span><span class="src-doc">   </span><span class="src-doc-var">$pPHPExcel </span></li>
<li><a name="a190"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">     Exception</span></li>
<li><a name="a191"></a><span class="src-doc">     */</span></li>
<li><a name="a192"></a>    <span class="src-key">private </span><span class="src-key">function </span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_Workbook.html#method_writeSheets">_writeSheets</a><span class="src-sym">(</span><span class="src-var">$objWriter </span>= <span class="src-id">null</span><span class="src-sym">, </span><span class="src-var">$pPHPExcel </span>= <span class="src-id">null</span><span class="src-sym">)</span></li>
<li><a name="a193"></a>    <span class="src-sym">{</span></li>
<li><a name="a194"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$objWriter </span>instanceof <span class="src-id">xmlWriter </span>&amp;&amp; <span class="src-var">$pPHPExcel </span>instanceof <span class="src-id"><a href="../PHPExcel/PHPExcel.html">PHPExcel</a></span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a195"></a>            <span class="src-comm">// Write sheets</span></li>
<li><a name="a196"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">startElement</span><span class="src-sym">(</span><span class="src-str">'sheets'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a197"></a>                </li>
<li><a name="a198"></a>            <span class="src-key">for </span><span class="src-sym">(</span><span class="src-var">$i </span>= <span class="src-num">0</span><span class="src-sym">; </span><span class="src-var">$i </span>&lt; <span class="src-var">$pPHPExcel</span><span class="src-sym">-&gt;</span><span class="src-id">getSheetCount</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">; </span><span class="src-var">$i</span>++<span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a199"></a>                <span class="src-comm">// sheet</span></li>
<li><a name="a200"></a>                <span class="src-var">$this</span><span class="src-sym">-&gt;</span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_Workbook.html#method_writeSheet">_writeSheet</a><span class="src-sym">(</span></li>
<li><a name="a201"></a>                    <span class="src-var">$objWriter</span><span class="src-sym">,</span></li>
<li><a name="a202"></a>                    <span class="src-var">$pPHPExcel</span><span class="src-sym">-&gt;</span><span class="src-id">getSheet</span><span class="src-sym">(</span><span class="src-var">$i</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">getTitle</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">,</span></li>
<li><a name="a203"></a>                    <span class="src-sym">(</span><span class="src-var">$i </span>+ <span class="src-num">1</span><span class="src-sym">)</span><span class="src-sym">,</span></li>
<li><a name="a204"></a>                    <span class="src-sym">(</span><span class="src-var">$i </span>+ <span class="src-num">1 </span>+ <span class="src-num">3</span><span class="src-sym">)</span></li>
<li><a name="a205"></a>                <span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a206"></a>            <span class="src-sym">}</span></li>
<li><a name="a207"></a>                </li>
<li><a name="a208"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">endElement</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a209"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a210"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Invalid parameters passed.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a211"></a>        <span class="src-sym">}</span></li>
<li><a name="a212"></a>    <span class="src-sym">}</span></li>
<li><a name="a213"></a>                    </li>
<li><a name="a214"></a>    <span class="src-doc">/**</span></li>
<li><a name="a215"></a><span class="src-doc">     * Write sheet</span></li>
<li><a name="a216"></a><span class="src-doc">     *</span></li>
<li><a name="a217"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">xmlWriter </span><span class="src-doc-var">$objWriter </span><span class="src-doc">        XML Writer</span></li>
<li><a name="a218"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">string </span><span class="src-doc">    </span><span class="src-doc-var">$pSheetname </span><span class="src-doc">        Sheet name</span></li>
<li><a name="a219"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">int </span><span class="src-doc">       </span><span class="src-doc-var">$pSheetId </span><span class="src-doc">            Sheet id</span></li>
<li><a name="a220"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">int </span><span class="src-doc">       </span><span class="src-doc-var">$pRelId </span><span class="src-doc">               Relationship ID</span></li>
<li><a name="a221"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">     Exception</span></li>
<li><a name="a222"></a><span class="src-doc">     */</span></li>
<li><a name="a223"></a>    <span class="src-key">private </span><span class="src-key">function </span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_Workbook.html#method_writeSheet">_writeSheet</a><span class="src-sym">(</span><span class="src-var">$objWriter </span>= <span class="src-id">null</span><span class="src-sym">, </span><span class="src-var">$pSheetname </span>= <span class="src-str">''</span><span class="src-sym">, </span><span class="src-var">$pSheetId </span>= <span class="src-num">1</span><span class="src-sym">, </span><span class="src-var">$pRelId </span>= <span class="src-num">1</span><span class="src-sym">)</span></li>
<li><a name="a224"></a>    <span class="src-sym">{</span></li>
<li><a name="a225"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$objWriter </span>instanceof <span class="src-id">xmlWriter </span>&amp;&amp; <span class="src-var">$pSheetname </span>!= <span class="src-str">''</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a226"></a>            <span class="src-comm">// Write sheet</span></li>
<li><a name="a227"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">startElement</span><span class="src-sym">(</span><span class="src-str">'sheet'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a228"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'name'</span><span class="src-sym">,         </span><span class="src-var">$pSheetname</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a229"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'sheetId'</span><span class="src-sym">,     </span><span class="src-var">$pSheetId</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a230"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'r:id'</span><span class="src-sym">,         </span><span class="src-str">'rId' </span>. <span class="src-var">$pRelId</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a231"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">endElement</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a232"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a233"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Invalid parameters passed.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a234"></a>        <span class="src-sym">}</span></li>
<li><a name="a235"></a>    <span class="src-sym">}</span></li>
<li><a name="a236"></a>    </li>
<li><a name="a237"></a>    <span class="src-doc">/**</span></li>
<li><a name="a238"></a><span class="src-doc">     * Write Defined Names</span></li>
<li><a name="a239"></a><span class="src-doc">     *</span></li>
<li><a name="a240"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">xmlWriter </span><span class="src-doc">    </span><span class="src-doc-var">$objWriter </span><span class="src-doc">        XML Writer</span></li>
<li><a name="a241"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@param </span><span class="src-doc">    </span><span class="src-doc-type">PHPExcel </span><span class="src-doc">   </span><span class="src-doc-var">$pPHPExcel </span></li>
<li><a name="a242"></a><span class="src-doc">     * </span><span class="src-doc-coretag">@throws</span><span class="src-doc">     Exception</span></li>
<li><a name="a243"></a><span class="src-doc">     */</span></li>
<li><a name="a244"></a>    <span class="src-key">private </span><span class="src-key">function </span><a href="../PHPExcel_Writer_Excel2007/PHPExcel_Writer_Excel2007_Workbook.html#method_writeDefinedNames">_writeDefinedNames</a><span class="src-sym">(</span><span class="src-var">$objWriter </span>= <span class="src-id">null</span><span class="src-sym">, </span><span class="src-var">$pPHPExcel </span>= <span class="src-id">null</span><span class="src-sym">)</span></li>
<li><a name="a245"></a>    <span class="src-sym">{</span></li>
<li><a name="a246"></a>        <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$objWriter </span>instanceof <span class="src-id">xmlWriter </span>&amp;&amp; <span class="src-var">$pPHPExcel </span>instanceof <span class="src-id"><a href="../PHPExcel/PHPExcel.html">PHPExcel</a></span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a247"></a>            <span class="src-comm">// Write defined names</span></li>
<li><a name="a248"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">startElement</span><span class="src-sym">(</span><span class="src-str">'definedNames'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a249"></a>                </li>
<li><a name="a250"></a>            <span class="src-key">for </span><span class="src-sym">(</span><span class="src-var">$i </span>= <span class="src-num">0</span><span class="src-sym">; </span><span class="src-var">$i </span>&lt; <span class="src-var">$pPHPExcel</span><span class="src-sym">-&gt;</span><span class="src-id">getSheetCount</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">; </span><span class="src-var">$i</span>++<span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a251"></a>                <span class="src-comm">// definedName for autoFilter</span></li>
<li><a name="a252"></a>                <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$pPHPExcel</span><span class="src-sym">-&gt;</span><span class="src-id">getSheet</span><span class="src-sym">(</span><span class="src-var">$i</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">getAutoFilter</span><span class="src-sym">(</span><span class="src-sym">) </span>!= <span class="src-str">''</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a253"></a>                    <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">startElement</span><span class="src-sym">(</span><span class="src-str">'definedName'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a254"></a>                    <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'name'</span><span class="src-sym">,            </span><span class="src-str">'_xlnm._FilterDatabase'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a255"></a>                    <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'localSheetId'</span><span class="src-sym">,    </span><span class="src-var">$i</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a256"></a>                    <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeAttribute</span><span class="src-sym">(</span><span class="src-str">'hidden'</span><span class="src-sym">,        </span><span class="src-str">'1'</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a257"></a>                        </li>
<li><a name="a258"></a>                    <span class="src-comm">// Create absolute coordinate and write as raw text</span></li>
<li><a name="a259"></a>                    <span class="src-var">$range </span>= <span class="src-id"><a href="../PHPExcel/PHPExcel_Cell.html">PHPExcel_Cell</a></span><span class="src-sym">::</span><a href="../PHPExcel/PHPExcel_Cell.html#methodsplitRange">splitRange</a><span class="src-sym">(</span><span class="src-var">$pPHPExcel</span><span class="src-sym">-&gt;</span><span class="src-id">getSheet</span><span class="src-sym">(</span><span class="src-var">$i</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">getAutoFilter</span><span class="src-sym">(</span><span class="src-sym">))</span><span class="src-sym">;</span></li>
<li><a name="a260"></a>                    <span class="src-var">$range</span><span class="src-sym">[</span><span class="src-num">0</span><span class="src-sym">] </span>= <span class="src-id"><a href="../PHPExcel/PHPExcel_Cell.html">PHPExcel_Cell</a></span><span class="src-sym">::</span><a href="../PHPExcel/PHPExcel_Cell.html#methodabsoluteCoordinate">absoluteCoordinate</a><span class="src-sym">(</span><span class="src-var">$range</span><span class="src-sym">[</span><span class="src-num">0</span><span class="src-sym">]</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a261"></a>                    <span class="src-var">$range</span><span class="src-sym">[</span><span class="src-num">1</span><span class="src-sym">] </span>= <span class="src-id"><a href="../PHPExcel/PHPExcel_Cell.html">PHPExcel_Cell</a></span><span class="src-sym">::</span><a href="../PHPExcel/PHPExcel_Cell.html#methodabsoluteCoordinate">absoluteCoordinate</a><span class="src-sym">(</span><span class="src-var">$range</span><span class="src-sym">[</span><span class="src-num">1</span><span class="src-sym">]</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a262"></a>                    <span class="src-var">$range </span>= <a href="http://www.php.net/implode">implode</a><span class="src-sym">(</span><span class="src-str">':'</span><span class="src-sym">, </span><span class="src-var">$range</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a263"></a>                    </li>
<li><a name="a264"></a>                    <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">writeRaw</span><span class="src-sym">(</span><span class="src-str">'\'' </span>. <span class="src-var">$pPHPExcel</span><span class="src-sym">-&gt;</span><span class="src-id">getSheet</span><span class="src-sym">(</span><span class="src-var">$i</span><span class="src-sym">)</span><span class="src-sym">-&gt;</span><span class="src-id">getTitle</span><span class="src-sym">(</span><span class="src-sym">) </span>. <span class="src-str">'\'!' </span>. <span class="src-var">$range</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a265"></a>                        </li>
<li><a name="a266"></a>                    <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">endElement</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a267"></a>                <span class="src-sym">}</span></li>
<li><a name="a268"></a>            <span class="src-sym">}</span></li>
<li><a name="a269"></a>                </li>
<li><a name="a270"></a>            <span class="src-var">$objWriter</span><span class="src-sym">-&gt;</span><span class="src-id">endElement</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a271"></a>        <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a272"></a>            throw <span class="src-key">new </span><span class="src-id">Exception</span><span class="src-sym">(</span><span class="src-str">&quot;Invalid parameters passed.&quot;</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a273"></a>        <span class="src-sym">}</span></li>
<li><a name="a274"></a>    <span class="src-sym">}</span></li>
<li><a name="a275"></a><span class="src-sym">}</span></li>
</ol></pre></div>
</div>
        <div class="credit">
		    <hr />
		    Documentation generated on Mon, 23 Apr 2007 12:56:55 +0200 by <a href="http://www.phpdoc.org">phpDocumentor 1.3.0RC3</a>
	      </div>
      </td></tr></table>
    </td>
  </tr>
</table>

</body>
</html>